{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","FILL_SALARY_DETAIL","TAX_PROFORMA","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["Read Instructin how to use this Income Tax Calculator"]
[1,"This is Maco Enable Book  so please Enable macro & Content"]
[]
["ਟੈਕਸ ਪ੍ਰ੍ਰਫਾਰਮਾ ਭਰਨ ਲਈ ਜਰਰੀ ਹਦਾਇਤਾਂ"]
[1,"ਅੇੈਕਸਲ 2010 ਜਾਂ ਇਸ ਤੋਂ ਉਪਰ ਦਾ ਆਫਿਸ ਦੀ ਵਰਤੋਂ ਕਰੌ"]
[2,"ਫਾਇਲ਼ ਖੁਲਣ ਤੇ Enabed Content And Enable Editing ਬਟਨ ਜੋ ਉਪਰ ਟੂਲਬਾਰ ਦੇ ਹੇਠਾ ਨਜ਼ਰ ਆਵੇਗਾ ਉਸ ਨੂੰ ਕਲਿੱਕ ਕਰੌ ਤਾਂ ਹੀ ਸਹੀ ਆਉਟਪੁੱਟ ਆਵੇਗੀ . ਜੇ ਅਜਿਹਾ ਕਰਨ ਤੋਂ ਰਹਿ ਗਿਆ ਤਾਂ ਫਾੲਲਿ ਨੂੰ ਦੁਬਾਰਾ ਬੰਦ ਕਰਕੇ ਉਪਨ ਕਰੋ"]
[3,"ਤਸੀ  Fill Salary Details ਸੀਟ ਤੇ  ਕਲਿੱਕ ਕਰਕੇ ਉਥੇ ਸਿਰਫ Grey Shaded ਖਾਨੇ ਹੀ ਭਰਨੇ ਹਨ"]
[4,"ਬੇਸਿਕ ਪੇਅ ਭਰੋ । ਗਰੇਡ ਪੇਅ ਖਾਲੀ ਛੱਡ ਦਿਉ ਜੇ ਲਾਗੂ ਨਹੀ ਹੁੰਦੀ ਹੈ"]
[5,"ਈ.ਪੀ.ਐਫ ਕੱਟਣਾ ਤਾਂ ਈਪੀ.ਐਫ ਵਿਚ Yes ਸਲੈਕਟ ਕਰੋ"]
[6,"ਤਰੱਕੀ ਦਾ ਮਹੀਨਾ ਸਿਲੈਕਟ ਕਰੋ। ਨਾਲ ਹੀ HRA ਰੇਟ ਵੀ ਸਿਲੈਕਟ ਕਰੋ"]
[7,"ਬੇਸਿਕ ਪੇਅ ਵਿਚ ਅਗਰ ਕਿਸੇ ਮਹੀਨੇ ਫਰਕ ਹੈ ਤੁਸੀ ਉਸ ਮਹੀਨਾ ਵਾਲੀ ਰੋਅ ਵਿਚ ਕਸਟਮ ਪੇ ਭੱਤੇ ਭਰ ਸਕਦੇ ਹੋ"]
[8,"ਇਸੇ ਤਰਾਂ ਕਟੋਤੀਆਂ ਸਿਲੈਕਰ ਕਰੋ , ਜੀਆਈ.ਅੇੈਸ ਸਿਲੈਕਟ ਕਰੋ, ਟੈਕਸ ਜਾਂ ਹੋਰ ਕੋਈ ਕੋਟਤੀ ਹੈ ਤਾਂ ਮਹੀਨੇ ਅਨੁਸਾਰ ਫਿੱਲ ਕਰੋ"]
[9,"ਕੁੱਲ ਤਨਖਾਹ ਚੈਕ ਕਰੋ। ਹੁਣ TAX PERMORMA ਸੀਟ ਤੇ ਜਾਉ"]
[10,"ਸਭ ਤੋਂ ਪਹਿਲਾ ਉਪਰ ਜੇ ਕਰ ਤੁਸੀ New TAX Regime ਵਿਚ ਆਉਦੇ ਹੋ ਤਾਂ Yes ਸਿਲੈਕਟ ਕਰੋ ਪੁਰਾਣੀ ਟੈਕਸ ਪ੍ਰਣਾਲੀ ਲਈ No ਸਿਲੈਕਟ  ਕਰੋ"]
[11,"ਹੁਣ ਆਪਣੀ ਕੋਈ ਹੋਰ ਇਨਕਮ ਅਤੇ ਕਟੋਤੀਆਂ ਦਾਖਲ ਕੋਰ"]
[12,"ਲਾਸਟ ਵਿਚ ਤੁਸੀ ਪੀਡੀ.ਐਫ ਦੇ ਰੂਪ ਵਿਚ ਸੇਵ ਕਰ ਸਕਦੇ ਹੋ"]
[13,"ਤੁਸੀ ਕਿਸੇ ਤਰਾਂ ਦੇ ਸੁਝਾਅ ਅਤੇ ਫੀਡਬੈਕ ਲਈ ਈਮੇਲ abhi072011@gmail.com ਤੇ ਸਪੰਰਕ ਕਰ ਸਕਦੇ ਹੋ"]
[14,"ਇਸੇ ਤਰਾਂ ਦੇ ਹੋਰ ਸਾਫਟਵੇਅਰ ਫਾਰਮ ਅਦਿ ਪ੍ਰਾਪਤ ਕਰਨ ਲਈ ਸਾਡੀ ਵੈਬਸਾਇਟ ਨੂੰ ਵਿਿਜਟ ਕਰੋ "]
[15,"Subscribe Our Youtube Channel for Details Video"]
[16,"Follow Us On Facebook"]

{"sheet":"FILL_SALARY_DETAIL","index":1,"n_rows":33,"n_cols":22,"rows_kept":33,"cut":false,"hidden":false,"merged":[[28,0,28,11],[28,20,28,23],[32,8,32,14],[5,15,5,17],[4,0,5,2],[31,17,33,22],[0,1,0,3],[0,4,0,21],[24,0,24,22],[2,9,2,13],[4,12,4,15],[1,19,1,21],[2,19,2,21],[1,16,1,18],[2,16,2,18],[1,0,1,2],[1,12,1,13],[1,15,2,15],[4,17,4,21],[2,0,2,2],[2,3,2,6],[3,0,3,2],[3,15,3,16],[5,10,5,13],[3,9,3,10],[3,13,3,14],[3,11,3,12],[2,7,2,8],[3,7,3,8],[4,7,4,8],[4,9,4,10],[3,3,3,6],[4,3,5,6]]}
[null,"Office Of  :",null,null,"Principal Govt. Sr. Sec. School ----------"]
["Salary Statement :",null,null,"for",null,"FY",2025,{"$f":"(\"-\"&G2+1)+2000","v":-26},"AY",{"$f":"G2+1","v":2026},{"$f":"H2-1","v":-27},null,null,null,null,"PERIOD","From",null,null,"To"]
["  Employee Name    :",null,null,"Name",null,null,null,"Designation :",null,"Computer Faculty",null,null,null,null,null,null,"2025-04-01",null,null,{"$f":"DATE(YEAR(Q3),MONTH(Q3)+12,DAY(Q3)-1)","v":"2026-03-31"}]
["Father's Name    :",null,null,"Father Name",null,null,null,"Date of Birth :",null,"1988-11-24",null,"PAN No. :",null,"CNTTL0000",null,"Pay in Pay Band",null,22190,"Grade Pay",5000,"EPF","Yes"]
["Resi. Address     :",null,null,"#5 Block Khanna Ludhiana",null,null,null,"Gender         :",null,"Male",null,"Jan","←Select Increment Month"]
[null,null,null,null,null,null,null,null,"HRA →",10]
["Month","Year","Pay in   Pay Band","Grade Pay","Basic Pay","Total Basic Pay","D.A. Rate","D.A.","H.R.A.","R.A.","No Spl All","Med.All.","Mob. All.","Any Other All.","Gross \nSalary","G.P.F./C.P.F./E.P.F.","G.I.S.","Income Tax","Dev.\nTax","Other Ded.","Total Ded.","Net Pay"]
["Mar",{"$f":"$G$2","v":2025},{"$f":"R4","v":22190},{"$f":"T4","v":5000},{"$f":"SUM(C8:D8)","v":27190},{"$f":"SUM(E8:E8)","v":27190},1.81,{"$f":"IF($R$5=\"Basic Pay\",0,(ROUND(F8*G8,0)))","v":49214},{"$f":"IF($R$5=\"Basic Pay\",0,(ROUND(F8*$J$6%,0)))","v":2719},{"$f":"IF(OR($R$5=\"Basic Pay\",$J$7=\"No R.A.\"),0,(ROUND(F8*6%,0)))","v":1631},{"$f":"IF($K$7=\"Spl. All.\",400,0)","v":0},{"$f":"IF($R$5=\"Basic Pay\",0,500)","v":500},300,null,{"$f":"ROUND(IF($R$5=\"Basic Pay\",C8,(F8+H8+I8+J8+K8+L8+M8)+N8),0)","v":81554},{"$f":"IF($V$4=\"Yes\",ROUND((1800),0),0)","v":1800},0,2000,200,null,{"$f":"SUM(P8:T8)","v":4000},{"$f":"O8-U8","v":77554}]
["Apr",{"$f":"$G$2","v":2025},{"$f":"CEILING(IF(A9=$L$5,((E8*3%)+C8),C8),10)","v":22190},{"$f":"D8","v":5000},{"$f":"SUM(C9:D9)","v":27190},27190,1.81,49214,{"$f":"IF($R$5=\"Basic Pay\",0,(ROUND(F9*$J$6%,0)))","v":2719},1631,{"$f":"IF($K$7=\"Spl. All.\",400,0)","v":0},500,300,null,81554,{"$f":"IF($V$4=\"Yes\",ROUND((1800),0),0)","v":1800},0,2000,200,null,{"$f":"SUM(P9:T9)","v":4000},{"$f":"O9-U9","v":77554}]
["May",2025,{"$f":"CEILING(IF(A10=$L$5,((E9*3%)+C9),C9),10)","v":22190},{"$f":"D9","v":5000},27190,27190,1.81,49214,2719,1631,0,500,300,null,81554,1800,0,2000,200,null,4000,77554]
["Jun",2025,22190,{"$f":"D10","v":5000},27190,27190,1.81,49214,2719,1631,0,500,0,null,81254,1800,0,2000,200,null,4000,77254]
["Jul",2025,22190,{"$f":"D11","v":5000},27190,27190,1.81,49214,2719,1631,0,500,300,null,81554,1800,0,2000,200,null,4000,77554]
["Aug",2025,22190,5000,27190,27190,1.81,49214,2719,1631,0,500,300,null,81554,1800,0,2000,200,null,4000,77554]
["Sep",2025,22190,5000,27190,27190,1.81,49214,2719,1631,0,500,300,null,81554,1800,0,2000,200,null,4000,77554]
["Oct",2025,22190,5000,27190,27190,1.81,49214,2719,1631,0,500,300,null,81554,1800,0,2000,200,null,4000,77554]
["Nov",2025,22190,5000,27190,27190,1.81,49214,2719,1631,0,500,300,null,81554,1800,0,2000,200,null,4000,77554]
["Dec",2025,22190,5000,27190,27190,1.81,49214,2719,1631,0,500,300,null,81554,1800,0,2000,200,null,4000,77554]
["Jan",{"$f":"$G$2+1","v":2026},23010,5000,28010,28010,1.81,50698,2801,1681,0,500,300,null,83990,1800,0,5000,200,null,7000,76990]
["Feb",{"$f":"$G$2+1","v":2026},23010,5000,28010,28010,1.81,50698,2801,1681,0,500,300,null,83990,1800,0,5000,200,null,7000,76990]
["Arrear1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P20:T20)","v":0},{"$f":"O20-U20","v":0}]
["Arrear2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["Arrear3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["Arrear4"]
[null,null,{"$f":"SUM(C8:C23)","v":267920},{"$f":"SUM(D8:D23)","v":60000},{"$f":"SUM(E8:E23)","v":327920},{"$f":"SUM(F8:F23)","v":327920},null,{"$f":"SUM(H8:H23)","v":593536},32792,19672,0,6000,3300,0,983220,21600,0,30000,2400,0,54000,929220]
["Disclaimer : Although every care has been taken while preparing this IT Calculator, however the author & Teachershelp.in are not responsible for any discrepancy causing economic loss/legal dispute. "]
[]
[]
[null,null,null,null,null,null,null,null,null,"www.teachershelp.in",null,null,null,null,null,null,null,null,null,"Signaure"]
["Note: Any Increment/difference in consecutive figures is shown in the red colour for your information purpose only."]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Gross Total Salary (including employer's 14% share of CPF)→",null,null,null,null,null,null,{"$f":"IF($R$5=\"CPF\",O24+Q33,0)","v":0},{"$f":"IF($R$5=\"CPF\",(P24)/10*14)","v":false}]

{"sheet":"TAX_PROFORMA","index":2,"n_rows":71,"n_cols":14,"rows_kept":71,"cut":false,"hidden":false,"merged":[[82,0,82,14],[64,11,64,13],[3,6,3,7],[3,8,3,9],[31,3,31,5],[35,11,51,11],[35,12,51,12],[72,5,74,6],[73,7,73,10],[65,5,65,9],[64,5,64,7],[55,1,56,1],[72,7,72,10],[74,7,74,10],[74,0,74,3],[55,9,56,9],[0,12,14,12],[22,12,22,13],[15,12,15,13],[1,0,1,2],[2,0,2,2],[1,5,1,7],[2,8,2,9],[67,0,67,9],[68,0,68,3],[3,0,3,2],[66,0,66,9],[0,0,0,10],[63,4,63,6],[62,4,62,6],[1,8,1,9],[4,2,4,5],[56,5,56,8]]}
["    PROFORMA FOR CALCULATING  INCOME TAX"]
["Financial Year",null,null,{"$f":"FILL_SALARY_DETAIL!G2&\"-\"&FILL_SALARY_DETAIL!G2-1999","v":"2025-26"},null,"Assesment Year:",null,null,{"$f":"FILL_SALARY_DETAIL!J2&FILL_SALARY_DETAIL!K2","v":"2026-27"}]
["Name Of Official :",null,null,{"$f":"FILL_SALARY_DETAIL!D3","v":"Name"},null,null,"Designation:",null,{"$f":"FILL_SALARY_DETAIL!J3","v":"Computer Faculty"}]
["Permanent Account No:",null,null,{"$f":"FILL_SALARY_DETAIL!N4","v":"CNTTL0000"},null,null,"Date Of Birth:",null,{"$f":"FILL_SALARY_DETAIL!J4","v":"1988-11-24"}]
["Residential Adress:",null,{"$f":"FILL_SALARY_DETAIL!D5","v":"#5 Block Khanna Ludhiana"},null,null,null,null,"Section 115BAC →",null,"No"]
[1,"Salary Income(Including all allowances &Perks etc.)",null,null,null,null,null,null,"Rs.",{"$f":"FILL_SALARY_DETAIL!O24","v":983220}]
[null,"(-)H.R.A.Exemptable",null,null,null,null,null,null,"Rs."]
[null,"(-)Standard Deduction (SD) ",null,null,null,null,null,null,"Rs.",{"$f":"IF(J5=\"Yes\",75000,50000)","v":50000}]
[null,"(-)Interest Of House Building Advance",null,null,null,null,null,null,"Rs."]
[null,"(-)Mobile Allowance/Conveyance Allowance/ROP",null,null,null,null,"ROP",null,"Rs.",{"$f":"H10","v":0}]
[2,"Net Salary Income",null,null,null,null,null,null,"Rs.",{"$f":"IF(J5=\"No\",J6-J7-J8-J9-J10,J6-J8-H10)","v":933220}]
[3,"Professional Tax/Entertainment Tax u/s16",null,null,null,null,null,null,"Rs.",{"$f":"IF(J5=\"No\",FILL_SALARY_DETAIL!S24,0)","v":2400}]
[4,"GROSS SALARY INCOME(2-3)…………………………………………………………...",null,null,null,null,null,null,"Rs.",{"$f":"IF(J5=\"No\",SUM(J11-J12),J11)","v":930820}]
[5,"Income From Other Sources"]
[null,"(a)Income from House Property",null,null,null,null,null,null,"Rs."]
[null,"(b)Capital Gains",null,null,null,null,null,null,"Rs.",null,null,null,"Agri Income calc"]
[null,"(c)Other Sources:UTI,Bank Interest,NSCs,Kissan Vikas Patras etc",null,null,null,null,null,null,"Rs."]
[null,"(d)Agriculture Income",null,null,null,null,null,null,"Rs.",null,null,null,{"$f":"J55","v":770820},"Deduction"]
[6,"Total Income(4+5)……………………………………………………………………………..",null,null,null,null,null,null,"Rs.",{"$f":"SUM(J13:J18)","v":930820}]
[7,"Deduction (U/S 80C to 80 U)",null,null,"i)","  80-C (Various Saving Investments & Deductions)(Max limit Rs.1.5 Lacs)",null,null,null,null,null,null,{"$f":"IF(M18<=250000,0,IF(M18<=500000,(M18-250000)*0.05,IF(M18<=1000000,(M18-500000)*0.2+12500,IF(M18>1000000,(M18-1000000)*0.3+112500))))","v":66664},{"$f":"IF(M18<=400000,0,IF(M18<=800000,(M18-400000)*0.05,IF(M18<=1200000,(M18-800000)*0.1+20000,IF(M18<=1600000,(M18-1200000)*0.15+60000,IF(M18<=2000000,(M18-1600000)*0.2+120000,IF(M18<=2400000,(M18-2000000)*0.25+200000,IF(M18>2400000,(M18-2400000)*0.3+300000)))))))","v":18541}]
[null,"1)GPF/EPF/VPF",null,null,null,null,"Rs.",{"$f":"FILL_SALARY_DETAIL!P24","v":21600},"Rs.",{"$f":"IF($J$5=\"No\",IF(H21<=150000,H21,150000),0)","v":21600},"Inc.",null,250000,400000]
[null,"2)P.P.F.",null,null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H22<=150000,H22,150000),0)","v":0},"Inc.",null,{"$f":"J18+M21","v":250000},{"$f":"J18+N21","v":400000}]
[null,"3)NSC's Purchased",null,null,null,null,"Rs.",null,"Rs.",0,"Inc.",null,"Exemp Tax"]
[null,"4)Fixed Bank Deposits (5 year lock-in period)",null,null,null,null,"Rs.",null,"Rs.",0,"Inc.",null,{"$f":"IF(M22<=250000,0,IF(M22<=500000,(M22-250000)*0.05,IF(M22<=1000000,(M22-500000)*0.2+12500,IF(M22>1000000,(M22-1000000)*0.3+112500,))))","v":0},{"$f":"IF(N22<=400000,0,IF(N22<=800000,(N22-400000)*0.05,IF(N22<=120000,(N22-800000)*0.1+20000,IF(N22<=1600000,(N22-1200000)*0.15+60000,IF(N22<=2000000,(N22-1600000)*0.2+120000,IF(N22<=2400000,(N22-2000000)*0.25+2000000,IF(N22>2400000,(N22-2000000)*0.3+3000000)))))))","v":0}]
[null,"5)Senior Citizens Saving Schemes (SCSS)",null,null,null,null,"Rs.",null,"Rs.",0,"Inc.",null,{"$f":"M20-M24","v":66664},{"$f":"N20-N24","v":18541}]
[null,"6)Equity Linked Saving Schemes (ELSS)",null,null,null,null,"Rs.",null,"Rs.",0,"Inc."]
[null,"7)Life Insurance Premium",null,null,null,null,"Rs.",null,"Rs.",0,"Inc."]
[null,"8)Unit Linked Insurance Plans (ULIPs)",null,null,null,null,"Rs.",null,"Rs.",0,"Inc."]
[null,"9)School Fees Paid for Education of Children",null,null,null,null,"Rs.",null,"Rs.",0,"Inc."]
[null,"10)Group Insurance Scheme (GIS)",null,null,null,null,"Rs.",{"$f":"FILL_SALARY_DETAIL!Q24","v":0},"Rs.",0,"Inc."]
[null,"11)Principal Repayment of House Loan",null,null,null,null,"Rs.",150000,"Rs.",150000,"Inc."]
[null,"12)Any Other(Show here→",null,"SMY",null,null,"Rs.",null,"Rs.",0,"Inc."]
["ii)","80-CCC",null,null,null,null,"Rs.",null,"Rs.",0,"Inc."]
["iii)","80-CCCD1(A)","NPS","(Max.1,50,000) Employee's share",null,null,"Rs.",null,"Rs.",0,"Inc."]
["iv)","80-CCCD1(B)","NPS","(Max.50,000)   Additional share",null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H35<=50000,H35,50000),0)","v":0},"Exclu."]
["v)","80-CCCD2","NPS","(No Limit)       Govt./Employer's share",null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",H36,0)","v":0},"Exclu.","Inc.= Including 80 C (1,50,000) limit"]
["vi)","80 CCG","Rajiv Gandhi Equity Saving Scheme (RGESS)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H37<=25000,H37,25000),0)","v":0},"Exclu."]
["vii)","80 D","(Premium paid for Medical Insurance)",null,null,"(Max.1,00,000)","Rs.",10000,"Rs.",{"$f":"IF($J$5=\"No\",IF(H38<=100000,H38,100000),0)","v":10000},"Exclu."]
["viii)","80 DD","(Medical Expenditure for a Handicapped Relative)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H39<=125000,H39,125000),0)","v":0},"Exclu."]
["ix)","80 DDB","(Medical Expenditure on Self or Dependent Relative)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H40<=100000,H40,100000),0)","v":0},"Exclu."]
["x)","80 E","(Interest on Education Loan for Higher Studies)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",H41,0)","v":0},"Exclu."]
["xi)","80 EE","(Interest on Home Loan-First Time Buyers)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H42<=50000,H42,50000),0)","v":0},"Exclu."]
["xii)","80EEA","(Interest on loan for house whose stamp duty < Rs. 45 lakhs)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H43<=150000,H43,150000),0)","v":0}]
["xiii)","80EEB","(interest on loan taken for purchase of an electric vehicle)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H44<=150000,H44,150000),0)","v":0}]
["xiv)","80-G","(Donations towards Social Causes)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",H45,0)","v":0},"Exclu."]
["xv)","80-GG","(Deduction for House Rent Paid where HRA is not received)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H46<=60000,H46,60000),0)","v":0},"Exclu."]
["xvi)","80 GGA","(Donations for Scientific Research/Rural development)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",H47,0)","v":0},"Exclu."]
["xvii)","80 GGC","(Donations made to political parties)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H48<=150000,H48,150000),0)","v":0},"Inc."]
["xviii)","80 QQB","(Royalty Income for Authors)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H49<=300000,H49,300000),0)","v":0},"Exclu."]
["xix)","80 RRB","(Deduction in respect of royalty on patents)",null,null,null,"Rs.",null,"Rs.",0,"Exclu."]
["xx)","80-TTA ","(Interest income of SB A/C upto 10000 & 50000 for Sr. Citi.)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H51<=10000,H51,10000),0)","v":0},"Exclu."]
["xxi)","80-U","(Deduction in case of a person with disability)",null,null,null,"Rs.",null,"Rs.",{"$f":"IF($J$5=\"No\",IF(H52<=125000,H52,125000),0)","v":0},"Exclu."]
[null,"TOTAL……………………………………………",null,null,null,{"$f":"SUM(J21:J34,J48)","v":171600},"Rs.",{"$f":"SUM(H21:H52)","v":181600},"Rs.",{"$f":"IF(J5=\"No\",F54,H54)","v":160000}]
[8,"a)Net Taxable Income(6-7)",null,null,null,{"$f":"IF(F53<=150000,(F53+J35+J36+J37+J38+J39+J40+J41+J42+J45+J46+J47+J49+J50+J51+J52+J43+J44),(150000+J35+J36+J37+J38+J39+J40+J41+J42+J43+J44+J45+J46+J47+J49+J50+J51+J52))","v":160000},null,{"$f":"J36","v":0},"Rs.",{"$f":"J19-J53","v":770820}]
[null,"b)Rounded Off to the multiple of ten rupees",null,null,null,null,null,null,"Rs.",{"$f":"IFERROR(MROUND(J54,10),0)","v":770820}]
[9,"Income Tax→",{"$f":"IF(J5=\"No\",\"Upto Rs. 250000/-…………………………NIL\",\"Upto Rs. 400000/-…………………………NIL\")","v":"Upto Rs. 250000/-…………………………NIL"},null,null,{"$f":"IF(J5=\"No\",\"Rs.250001/- to 500000/-……..@,5%\",\"Rs.400001/- to 800000/-……..@5%\")","v":"Rs.250001/- to 500000/-……..@,5%"},null,null,"Rs.",{"$f":"IF(J5=\"No\",M25,N25)","v":66664}]
[null,null,{"$f":"IF(J5=\"No\",\"Rs.500001/- to 1000000/-……..@,20%\",\"Rs.800001/- to 1200000/-……..@10%\")","v":"Rs.500001/- to 1000000/-……..@,20%"},null,null,{"$f":"IF(J5=\"No\",\"Above Rs 10,0000…..@,30%\",\"Rs.12L/- to 16L/-.@15%, Rs 16L to 20L.@20% & 25%@30% \")","v":"Above Rs 10,0000…..@,30%"}]
[null,{"$f":"IF(J5=\"No\",\"Deduction u/s 87a if taxable income under 5 lac (Max. 12500)\",\"Deduction u/s 87a if taxable income under 12 lac (Max. 60000)\")","v":"Deduction u/s 87a if taxable income under 5 lac (Max. 12500)"},null,null,null,null," ",{"$f":"IF(J55>500000,0,IF(J56<=12500,J56,12500))","v":0},"Rs.",{"$f":"IF(J5=\"No\",H58,K58)","v":0},{"$f":"IF(J55>1200000,0,IF(J56<=60000,J56,60000))","v":60000}]
[null,"TOTAL TAX……………………………………………………………………………",null,null,null,null,null,null,null,{"$f":"ROUND(J56-J58,0)","v":66664}]
[10,"Add Surcharge @ at S No8",null,null,null,null,null,{"$f":"IF(J54>=5000000,J56*10%,IF(J54>10000000,J56*15%,IF(J54>20000000,J56*25%,IF(J54>50000000,J56*37%,0))))","v":0},"Rs.",{"$f":"IF(J5=\"No\",H60,0)","v":0}]
[11,"Total Tax Payable (9+10)",null,null,null,null,null,null,"Rs.",{"$f":"SUM(J59:J60)","v":66664}]
[12,"Health & Education Cess @ 4% on Total Tax at S. No. 11 (New)",null,null,null,null,null,null,"Rs.",{"$f":"ROUND(J61*4%,0)","v":2667}]
[14,"Net Tax Payable(11+12)",null,null,"(Enter Relief U/S 89 U here)→",null,null,null,"Rs.",{"$f":"SUM(J61:J62)-(H63)","v":69331}]
[15,"Tax Already Paid",null,null,"(If any other tax paid in 26 AS, add→",null,null,null,"Rs.",{"$f":"SUM(FILL_SALARY_DETAIL!R8:R23)+H64","v":30000}]
[16,"Tax Status",null,null,null,{"$f":"IF(J63>J64,\"Balance Tax Payable →\",IF(J64>J63,\"Tax Refund →\",\"No Tax Required →\"))","v":"Balance Tax Payable →"},null,null,"Rs.",{"$f":"(IF(J63>J64,J63-J64,IF(J64>J63,J64-J63,0)))","v":39331}]
[null,null,null,null,null,{"$f":"EnglishNumber(J65)","v":"Thirty-Nine Thousand Three Hundred Thirty-One"}]
["DECLARATION: I undertake to supply the documentry proof of deductions claimed above.I shall be personally responsible "]
["to file return with income tax deptt,as required under the law & also be liable to face consequence for wrong information"]
[" supplied & income concealed if any",null,null,null,null,null,null,"sign"]
[null,"Date:",{"$f":"TODAY()","v":"2025-12-27"},null,null,null,null,{"$f":"D3","v":"Name"}]
[null,null,null,"www.teachershelp.in",null,null,null,{"$f":"FILL_SALARY_DETAIL!G1","v":0}]

{"sheet":"Sheet1","index":3,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Available Exemptions/ Deductions","Old Tax Regime","New Tax Regime",null,null,null,null,null,"Income Tax Slabs","Tax Rates (in % p.a.)",null,null,null,"old"]
["Standard Deductions of Rs. 50,000","YES","YES",null,null,null,null,null,"Up to Rs. 3 lakhs","NIL",null,null,null,"0-2.5L",0]
["Employment/ Professional Tax u/ Sec 10(5)","YES","NO",null,null,null,null,15000,"Rs. 3 lakhs- Rs. 6 lakhs",0.05,"87A releif",null,null,"2.5-5",5,"87A rebate upto 5l"]
["House Rent Allowance (HRA) u/ Sec 10(13A)","YES","NO",null,null,null,17500,30000,"Rs. 6 lakhs- Rs. 9 lakhs",0.1,"7 lack u/s 87",null,null,"5.-10l",20]
["Exemptions for Free Food & Beverages through Vouchers/ Food Coupons","YES","NO",null,null,null,null,45000,"Rs. 9 lakhs- Rs. 12 lakhs",0.15,null,null,null,"10+",30]
["Deductions of Up to Rs. 1.5 lakhs u/ Chapter VIA towards investments like u/ Sec 80C, 80CCC, 80CCD, 80DD, 80DDB, 80E, 80EE, 80EEA, 80G, etc.","YES","NO",null,null,null,null,60000,"Rs. 12 lakhs- Rs. 15 lakhs",0.2]
["Deductions u/ Sec 80CCD(2) for Employer’s Contribution to Employee NPS Accounts","YES","YES",null,null,null,null,null,"Rs. 15 lakhs & Above",0.3]
["Deductions u/Sec 80CCD(1B) of Up to Rs. 50,000","YES","NO",null,null,null,null,null,"Education Cess","4% p.a. of Taxable Income"]
["Medical Insurance Premium u/Sec 80D","YES","NO"]
["Interest on Home Loan for Self-Occupied/ Vacant Property","YES","NO"]